Order Description
This assignment contains 2 exercises contributing to Portfolio– task 1 (40%) and task 2 (60%). The 2 tasks combined are worth 100% of the total marks for the module.

Business Scenario The Managing Director of Rose Ltd is considering purchasing office productivity software for
her employees but is unsure of the cost, or the benefits, of such a purchase.
You have been employed to achieve two tasks: task 1) to calculate the costs of this purchase, and task 2) to describe some benefits of the software.

! Coursework)Assignment)Brief)!
Semester:! A16! Module!Code:!!! ICSK3005! Module!Title:! Introduction!to!Computing!Skills! Programme!! Year!0! Level:! Level!3! Awarding!Body:!! Plymouth!University! Module!Leader! Thikrait!AlHMosawi! Format:!! Portfolio!! Presentation:!! None!! Special!requirements:!! None!
Word!Limit:!! Spreadsheet:!Not!applicable.! WordHprocessed!file:!1000!word!maximum,!excluding!screenshots.! Submission!Deadline:! Both!tasks!are!due!on!Tuesday!2pm!midday,!19th!April!2016!!
Learning!outcomes!to! be!examined!in!this! assessment!!
•” Demonstration!of!the!fundamentals!of!operating!a!computer! system!to!restore,!retrieve,!analyse!and!present!data.! •” Describe!the!ways!in!which!information!technology!can!contribute! to!increased!productivity!and!enhance!the!quality!of!management.! •” Describe!the!scope!of!hardware!&!software!currently!in!use!and!the! technological!advances!taking!place.!!
Percentage!of!marks! awarded!for!module:!
This!assignment!contains!2!exercises!contributing!to!Portfolio–!task!1! (40%)!and!task!2!(60%).!The!2!tasks!combined!are!worth!100%!of!the! total!marks!for!the!module.!! )
Exercises!contributing!to!Portfolio! ) Business)Scenario! The!Managing!Director!of!Rose!Ltd!is!considering!purchasing!office!productivity!software!for! her!employees!but!is!unsure!of!the!cost,!or!the!benefits,!of!such!a!purchase.!!! You!have!been!employed!to!achieve!two!tasks:!task!1)!to!calculate!the!costs!of!this! purchase,!and!task!2)!to!describe!some!benefits!of!the!software.!!! ! Task)1:)Spreadsheet)(40%)of)total)marks)! Calculate!costs!for!the!products!below,!using!a!spreadsheet.! ! Product)Types! Cost)(excluding)VAT)! Quantity! Microsoft!Word! £10.00! 10! Microsoft!Excel! £20.00! 25! Microsoft!Powerpoint! £30.00! 14! ! ! Task)1)Instructions) ! 1)” Rename!the!first!worksheet!in!your!spreadsheet!to!“Product”.!(1!mark)! ! 2)” Add!the!title!“Product!Costs”!at!the!top!of!your!worksheet.!(1!mark)! ! 3)” Format!the!title!H!consider!font!style,!font!size,!text!colour,!cell!background!colour,! text!alignment!or!merged!cells.!!(1!mark)! ! 4)” Use!an!appropriate!function!to!calculate!today’s!date.!(5!marks)! ! 5)” For!each!product!type!(Word,!Excel,!Powerpoint),!write!a!formula!to!calculate!the! total!cost!excluding!VAT.!(10!marks)! ! 6)” For!each!product!type!(Word,!Excel,!Powerpoint),!write!a!formula!to!calculate!the! total!cost!including!17.5%!VAT.!(12!marks)!!! ! 7)!Format!all!currency!as!£,!to!two!decimal!places,!e.g.!£2.00!(1!mark)! ! 8)!Using!an!IF!function,!output!the!words!“Over!Budget”!where!total!cost!of!each)) product!is!greater!than!£150.00,!and!“Under!Budget”!where!total!cost!of!product!is!! under!£151.!(9!marks)! ! ! )
How)to)submit)your)spreadsheet:!! Place!screenshots!of!your!spreadsheet!in)data)view!AND!formula)view!in!the!Appendix!of! your!report!(Task!2).!!You!must!show!both!views!to!be!marked.!
Task)2:)Report)(60%)of)total)marks)! ) The!managing!director!of!Rose!Ltd!does!not!have!much!experience!with!software,!and!has! asked!that!you!prepare!a!report!to:! 1)!compare!the!benefits!and!features!of!word!processing!software!to!presentation!software!! ! 2)!recommend!a!software!for!a)!delivering!a!presentation!to!the!board,!and!b)!writing!the! minutes!of!the!board!meeting!! ! ! Prepare!a!report!to!answer!her!questions.!It!should!address!the!following!topics:! ! 1.” Definition!of!word!processing!software! 2.” Benefits!of!word!processing!software! 3.” Key!features!of!word!processing!software! (15!marks)! ! 4.” Definition!of!presentation!software! 5.” Benefits!of!presentation!software! 6.” Key!features!of!presentation!software! (15!marks)! ! 7.” Recommend!a!software!for!a)!delivering!a!presentation!to!the!board!(5!marks),!and! b)!writing!the!minutes!of!the!board!meeting!(5!marks)! ! ! Structure!your!report!using!the!appropriate!word!processing!tools:! Cover!page!(3!marks)! Table!of!contents,!and!headings!(5!marks)! Referencing!and!Bibliography!!(10!marks)! Appendix!section!(2!marks)! ! ) Add)screenshots)of)your)spreadsheet)(data)and)formula)view))to)the)Appendix)section)of) your)report.! ) )
Suggested)report)structure) ! Cover)Page)! Assignment!title,!module!code,!student!name,!student!number!and!submission!date.! ! Table)of)Contents)! ! A!list!of!headings!and!page!numbers.! ! Introduction)(about)5%)of)word)count)! ?” What!question/topics!are!you!going!to!explore?!Why?!! ?” Explain!the!steps!you!will!take!to!address!the!question.!! ! Investigation)(about)80%)of)word)count)! ! Separate!your!investigations!into!topics!–!create!a!subheading!per!topic.!! Create!a!chain!of!paragraphs!under!each!subheading!(1!idea!per!paragraph).!! In!each!paragraph!the!reader!is!asking!you!to!explain:! ?” What!idea!is!this!paragraph!about?!! ?” What!are!your!evidences!on!this!idea?!What!do!these!evidences!tell!us?!! ?” How!does!this!paragraph!link!to!the!report!title?!! ?” How!does!it!link!to!the!topic!in!the!next!paragraph?!! ! Charts,!diagrams!and!tables!can!be!used!to!reinforce!your!arguments.! ! Recommendations)(about)10%)of)word)count)! Based!on!your!investigations,!outline!your!recommendations.!! ! Conclusion)(about)10%)of)word)count)! ?” Do!not!introduce!any!NEW!material!here.!!! ! ?” Restate!what!you!consider!the!main!points.!! ?” Make!it!clear!why!those!conclusions!are!important!or!significant.!!! ?” In!your!last!sentence,!link!your!conclusions!or!recommendations!back!to!the!title.! Did!you!answer!your!main!question?!What!was!the!answer?! ! Bibliography! ! An!alphabetically!ordered!list!of!the!references!cited!in!your!report,!in!Harvard!style.! ! Appendix)) Place!screenshots!of!spreadsheet!from!Task!1!here,!in!both!data!view!and!formula!view.! ) Example!of!data!view!! ! ! ! Example!of!formula!view!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

1
Generic’Criteria’for’Assessment’at’Level’3! Marks’for’ Level’3! 0725′(Fail) 26739′(Fail) 40749′(3rd) 50759′(2.2) 60769′(2.1) 70785′(1st) 867100′(1st) Knowledge’&’ Understanding’of’ Subject! Inadequate! understanding! of!and!major! gaps!in! knowledge.! Significant! inaccuracies.! Limited! understanding!of! and!large!gaps!in! knowledge!evident.! Some!inaccuracies.! Threshold’level.! Basic!and!broadly! accurate! knowledge!and! understanding!of! the!material.!Some! elements!missing! and!flaws!evident.! Satisfactory,! routine! knowledge!and! understanding!of! the!material,!main! concepts!! Some!flaws!may!be! evident.! Good,!consistent! knowledge!and! understanding!of!the! material,!main! concepts!at!this! level.! Excellent!knowledge! and!understanding!of! the!main!concepts!at! this!level.!! Exceptional! knowledge!and! understanding!of! Material!and!concepts! at!this!level.! ! Cognitive/! Intellectual’Skills!
(e.g.!analysis!and! synthesisE!logic! and!argumentE! analytical! reflectionE! organisation!and! communication!of! ideas!and! evidence)!
Inadequate! views!based! on!personal! opinion.! Complete!lack!of! supporting! evidence.! Inadequate!or! complete!lack!of! conclusions.!
Limited!logic!and! analysis,!and!lack! of!consistent! argument.!Points! generally! descriptive!and!at! times!incoherent.!
!
Conclusions! lack! validity.!
Threshold’level.! Basic!awareness! of! issues.! Some! logical! arguments! evident.! Lacks! coherence!in!places.!! Some!inconsistency! in!evidence!to! support!views.! Some!broadly!valid! conclusions! included.!
Issues!identified! satisfactorily!within! given!areas.! Demonstration!of! the!ability!to!use! evidence!to!support! a!coherent! argument.! Some! generally! valid! conclusions! included.!
Good!analytical! ability.! Arguments!generally! logical,!largely! balanced,! coherently! expressed!and! supported!with! evidence.! Sound!conclusions! included.!
Excellent!logical! analysis! throughout.! Persuasive!points! made!within!given! areas!of!the!work..! Arguments!wellK! balanced!!and! logically!developed! and!supported!! with!a!range!of! evidence.! Strong!conclusions! included.!
Exceptionally!logical! analysis!throughout.! Persuasive! arguments!included! throughout!!the! work!supported!by! appropriately! selected!evidence.! Convincing!!! conclusions! included.!
Use’of! Research7′ informed! Literature! (including! referencing,! appropriate! academic! conventions!and! academic!honesty)!
Inadequate! evidence!of! any! background! reading.!Views! are!inadequately! supported.! Inadequate!/!no! use!of!academic! conventions!at! this!level.! !
Evidence!of!limited! reading!around!the! topic!of!the!work.! Sources! inaccurately! utilised.! Limited!use!of! academic! conventions!at! this!level.!
Threshold’level.! Some!evidence!of! reading!around!the! topic!of!the!work.!! Basic!academic! conventions! followed!at!this! level,!but!with! errors.!
Satisfactory! range!of! literature!used! mainly! descriptively.! Academic!skills! generally!sound! at!this!level.!
Good!range!of! relevant!literature! generally!used! critically!to!inform! argument.!! Good!use!of! academic! conventions!at!this! level.!
Excellent!range!of! relevant!literature! used!critically!to! inform!argument.! Consistently!accurate! use!of!academic! conventions!at!this! level.!
Exceptional!range! of!relevant! literature!used!critically! to!inform!argument.! !Consistently! accurate!and!skilful! use!of!academic! conventions!at!this! level.!

2
LEVEL’3’cont…! Graduate’Skills’ for’Life’and’ Employment! (e.g.!!researchK! related!skillsE! written,!graphical! and!oral! communication! skillsE! group!workingE! problemKsolvingE! practical!and! professional!skills)!
Little!or!no! evidence!of!the! required!skills!in! any!of!the!skills! areas.!
Limited!evidence!of! skills!in!the!range! identified!for!the! assessment!at!this! level.! Significant! weaknesses! evident,!which! suggest!that!the! candidate!is!not!on! course!to!gain!skills! necessary!for! progression!on!to! level!4.! !
Research’skills:! Basic!data!collection! and!interpretation!/! research!skills!at!this! level!with!external! guidance! Communication’ skills:!Able!to!! communicate!both! orally!and!in!the! written!form!with! some!limitations! Group’working’ skills:”Basic!group! work!skills.!Meets! most!obligations!to! peers!and!tutors! Problem7solving’ skills:!Basic! application!of! problemKsolving! methods!and!some! appreciation!of! potential!range!of! issues!in!the! discipline! Practical’and’ professional’ skills:!Basic!ability! to!evaluate!own! strengths!and! weaknesses!in! relation!to! professional!and! practical!skills!at! this!level!! !
Research’skills:! Communication’ skills:!Satisfactory! data!collection!and! interpretation!/! research!skills!at! this!level!with!some! external!guidance! ‘Communication’ skills:’Able!to!! communicate! satisfactorily!both! orally!and!in!the! written!form! Group’working’ skills:!Satisfactory! group!work!skills! including! leadership!where! necessary.!Meets! most!obligations!to! peers!and!tutors.! Problem7solving’ skills:!satisfactory! application!of! problemKsolving! methods!and!some! appreciation!of! potential!range!of! issues!in!the! discipline! Practical’and’ professional’skills:!! Ability!to!evaluate! own!strengths!and! weaknesses!in! relation!to! professional!and! practical!skills!at!this! level!
Research’skills:! Good!data!collection! and!interpretation!/! research!skills!at!this! level!with!minimal! external!guidance! ‘Communication”’ skills:!Able!to!! communicate!well!both! orally!and!in!the! written!form! Group’working’skills:’ Good!group!work! skills!including! leadership!where! necessary.!Meets! most!obligations!to! peers!and!tutors! consistently.! Problem7solving’ skills:’effective! application!of! problemKsolving! methods!and!some! appreciation!of!the! potential!range!of! issues!in!the! discipline’ Practical’and’ professional’skills:!! Clear!ability!to! evaluate!own! strengths!and! weaknesses!in! relation!to! professional!and! practical!skills!at! this!level!
Research’skills:! Excellent!data! collection!and! interpretation!/! research!skills!at!this! level.! Communication’ skills:’ Able!to!communicate! excellently!both!orally! and!in!the!written!form! Group’working’ skills:’Excellent! group!work!skills! including!leadership! where!necessary.! Meets!all!obligations! to!peers!and!tutors! consistently.! Problem7solving’ skills:! Highly!effective! application!of! problemKsolving! methods!and!an! appreciation!of!the! potential!range!of! issues!in!the! discipline.! ‘Practical’and’ professional’skills:! Excellent!ability! to!evaluate!own! strengths!and! weaknesses!in! relation!to! professional!and! practical!skills!at! this!level.!
Research’skills:! Exceptional!data! collection!and! interpretation!/! research!skills!at!this! level.! Communication’skills:’ Able!to!communicate’ exceptionally!both!orally! and!in!the!written!form! Group’working’skills:’ Exceptional!group!work! skills!including! leadership!where! necessary.!Meets!all! obligations!to!peers!and! tutors!at!all!times.! Problem7solving’ skills:! Exceptionally!effective! application!of!problemK solving!methods!and!a! high!appreciation!of!the! potential!range!of! issues!in!the!discipline.! Practical’and’ professional’skills:! Exceptional!ability!to! evaluate!own!strengths! and!weaknesses!in! relation!to!professional! and!practical!skills!at! this!level.!

3